[dbo].[Security

[dbo].[Security_Group]

SQLServer > iMIS1521GA > Views > dbo.Security_Group

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:38:08 PM Friday, January 07, 2011
Last Modified	1:46:13 PM Thursday, September 22, 2011

Columns

Name
SecurityGroupCode
SecurityGroupName

Permissions

Type	Action	Owning Principal
Grant	Select	IMIS

SQL Script

CREATE      VIEW Security_Group
AS
  SELECT SECURITY_GROUP AS SecurityGroupCode, SECURITY_GROUP AS SecurityGroupName
    FROM Security_Groups
  UNION
  SELECT MEMBER_TYPE, DESCRIPTION + ' (Member Type)'
    FROM Member_Types
   WHERE MEMBER_TYPE NOT IN (SELECT SECURITY_GROUP FROM Security_Groups)

GO
GRANT SELECT ON  [dbo].[Security_Group] TO [IMIS]
GO

Uses

[dbo].[Member_Types]
[dbo].[Security_Groups]
dbo